package com.briup.cms.dao;

import com.briup.cms.bean.Notes;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface NotesMapper {
  @Select("select * from cms_notes")
    List<Notes>selectAll();
  @Insert("insert into cms_notes values(null #{title},#{content},#{type},#{status},#{user_id})")
  int insert(Notes notes);
  @Update("update cms_notes set title=#{title},content=#{content},type=#{type},status=#{status},user_id=#{userId} where id=#{id}")
  int update(Notes notes);
  @Delete("delete from cms_notes where id=#{id}")
  int deleteById(long id);

}
